If you open the Properties for any DBMS library defined in SAS^® Management Console and navigate to the Options tab, then click the Advanced Options button and navigate to the Optimization tab, you will see a section at the bottom of the window labeled Pass generated SELECT SQL to the DBMS. If you make certain changes to the settings in this section, these changes are not saved to the SAS^® Metadata Repository.

For example, click the radio button for Exceptions to DBMS Processing and move NOWHERE to the selected items side, then click OK to back your way out of the library properties. Right–click on the Library object and choose Display libname. You will see that the DIRECT_SQL option does not appear in the generated LIBNAME statement as it should. Now, navigate back into the Advanced Options Optimization tab, and you will see that the DBMS Processing button is once again selected (and set to Yes) and the NOWHERE setting is gone from the Exceptions to DBMS Processing Selected items.

Another manifestation of this issue occurs when you change the value of DBMS Processing from Yes to NONE and save the changes. This change is saved successfully. However, if you then try to change the value from NONE back to Yes or No, the value always reverts to NONE.

Currently, the only workaround to ensure the library is assigned with the correct value is to mark the library as pre–assigned and add a LIBNAME statement to your server's autoexec file. You can then include the DIRECT_SQL= option on your LIBNAME statement and set it to the value you require.

Operating System and Release Information